USE StrongHold
Go

select CCode, CName
from Customer
where CCode = 'TLT';

select *
from OrderMaster
where CCode in ('TLT','BGL');

select OrderNo,ItemCode, Qty
from OrderDetails
where OrderNo = '0083/98' and ItemCode='STCS';

select *
from Item
where Rate > 1500;